Film_Locations_in_San_Francisco

Data source: data.sfgov.org

12 rows where Release Year = 13

View and edit SQL

Suggested facets: Title, Production Company, Distributor, Director, Writer, Actor 1, Actor 2

Link rowid ▼ Title Release Year Locations Fun Facts Production Company Distributor Director Writer Actor 1 Actor 2 Actor 3
45 Alcatraz 15 2012 13 Filbert St. from Jones to Mason   Bonanza Productions Inc. 12 Warner Bros. Television 11 J.J. Abrams 14 Steven Lilien 13 Sarah Jones 249 Jorge Garcia 13  
46 Alcatraz 15 2012 13 Leavenworth from Filbert & Francisco St   Bonanza Productions Inc. 12 Warner Bros. Television 11 J.J. Abrams 14 Steven Lilien 13 Sarah Jones 249 Jorge Garcia 13  
47 Alcatraz 15 2012 13 Chestnut St. from Larkin to Columbus   Bonanza Productions Inc. 12 Warner Bros. Television 11 J.J. Abrams 14 Steven Lilien 13 Sarah Jones 249 Jorge Garcia 13  
48 Alcatraz 15 2012 13 Francisco St from Larkin to Polk   Bonanza Productions Inc. 12 Warner Bros. Television 11 J.J. Abrams 14 Steven Lilien 13 Sarah Jones 249 Jorge Garcia 13  
49 Alcatraz 15 2012 13 Broadway from Mason to Taylor   Bonanza Productions Inc. 12 Warner Bros. Television 11 J.J. Abrams 14 Steven Lilien 13 Sarah Jones 249 Jorge Garcia 13  
50 Alcatraz 15 2012 13 Taylor St. from Broadway to Filbert   Bonanza Productions Inc. 12 Warner Bros. Television 11 J.J. Abrams 14 Steven Lilien 13 Sarah Jones 249 Jorge Garcia 13  
388 CSI: NY- episode 903 70 2012 13 Palace of Fine Arts   CBS Television Studios 53 Columbia Broadcasting System 22 Vikki Williams 64 Anthony E. Zuiker 63 Gary Sinise 287 Sela Ward 52  
995 On the Road 182 2012 13 Bay Bridge   SPAD Films 114 IFC Films & Sundance Selects 71 Walter Salles 151 Jack Kerouac & Jose Rivera 157 Garrett Hedlund 352 Viggo Mortenson 139  
996 On the Road 182 2012 13 Sacramento & Montgomery Streets   SPAD Films 114 IFC Films & Sundance Selects 71 Walter Salles 151 Jack Kerouac & Jose Rivera 157 Garrett Hedlund 352 Viggo Mortenson 139  
997 On the Road 182 2012 13 2017 23rd Street   SPAD Films 114 IFC Films & Sundance Selects 71 Walter Salles 151 Jack Kerouac & Jose Rivera 157 Garrett Hedlund 352 Viggo Mortenson 139  
998 On the Road 182 2012 13 Filbert & Leavenworth Streets   SPAD Films 114 IFC Films & Sundance Selects 71 Walter Salles 151 Jack Kerouac & Jose Rivera 157 Garrett Hedlund 352 Viggo Mortenson 139  
1446 The Master 268 2012 13 Pier 7/ Embarcadero   H.H. Project 159 Weinstein Company 21 Paul Thomas Anderson 221 Paul Thomas Anderson 232 Philip Seymour Hoffman 143 Joaquin Phoenix 205  

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE "Film_Locations_in_San_Francisco" (
"Title" INTEGER,
  "Release Year" INTEGER,
  "Locations" TEXT,
  "Fun Facts" REAL,
  "Production Company" INTEGER,
  "Distributor" INTEGER,
  "Director" INTEGER,
  "Writer" INTEGER,
  "Actor 1" INTEGER,
  "Actor 2" INTEGER,
  "Actor 3" INTEGER
,
FOREIGN KEY ("Title") REFERENCES [Title](id),
    FOREIGN KEY ("Director") REFERENCES [Director](id),
    FOREIGN KEY ("Actor 2") REFERENCES [Actors](id),
    FOREIGN KEY ("Actor 1") REFERENCES [Actors](id),
    FOREIGN KEY ("Writer") REFERENCES [Writer](id),
    FOREIGN KEY ("Release Year") REFERENCES [Release Year](id),
    FOREIGN KEY ("Actor 3") REFERENCES [Actors](id),
    FOREIGN KEY ("Production Company") REFERENCES [Production Company](id),
    FOREIGN KEY ("Distributor") REFERENCES [Distributor](id));
CREATE INDEX ["Film_Locations_in_San_Francisco_Title"] ON [Film_Locations_in_San_Francisco]("Title");
CREATE INDEX ["Film_Locations_in_San_Francisco_Director"] ON [Film_Locations_in_San_Francisco]("Director");
CREATE INDEX ["Film_Locations_in_San_Francisco_Actor 2"] ON [Film_Locations_in_San_Francisco]("Actor 2");
CREATE INDEX ["Film_Locations_in_San_Francisco_Actor 1"] ON [Film_Locations_in_San_Francisco]("Actor 1");
CREATE INDEX ["Film_Locations_in_San_Francisco_Writer"] ON [Film_Locations_in_San_Francisco]("Writer");
CREATE INDEX ["Film_Locations_in_San_Francisco_Release Year"] ON [Film_Locations_in_San_Francisco]("Release Year");
CREATE INDEX ["Film_Locations_in_San_Francisco_Actor 3"] ON [Film_Locations_in_San_Francisco]("Actor 3");
CREATE INDEX ["Film_Locations_in_San_Francisco_Production Company"] ON [Film_Locations_in_San_Francisco]("Production Company");
CREATE INDEX ["Film_Locations_in_San_Francisco_Distributor"] ON [Film_Locations_in_San_Francisco]("Distributor");
Powered by Datasette · Query took 33.622ms · Data source: data.sfgov.org